This forum is closed to new posts and
responses. The content has been migrated to the Digital Solutions Community. Please join us there for new content as well as this content. For customer support, please visit the official HCL customer support channels below:
~Yoshi Quetkisterikle 12.Jan.04 03:57 PM a Web browser Notes Client6.0.3Windows 2000
I am attempting to retreive a range of records from an Oracle database to convert to Notes documents using an ODBC connection. I have a Select statement that retrieves all records between two dates. If I cut and paste my Select statement into Toad and run it against the data base, I get all the records as I would expect. When I run it in my Notes procedure, I get only today's records, if today's date is in the search, else I get zero records. Here is my Select statement:
OraQuery.SQL = "SELECT * FROM ORACLE_TABLE WHERE TRUNC(MY_DATE) > TO_DATE('" + sDATE.DateOnly + "','MM/DD/YYYY') - 1 AND TRUNC(MY_DATE) < TO_DATE('" + eDATE.DateOnly + "','MM/DD/YYYY') + 1"
Does anyone have any idea why Notes doesn't like this?
Return to top
Problems with ODBC Select statement... (~Yoshi Quetkist... 12.Jan.04)
. . 
Print this page
